Special Instructions: Press CTL and CLICK on image below to view the contents of each item via an internet HTML link.

EARLY Dashboards	Video Demo	ETL/ELT Script	Entry Brief	Arrick

SOLUTION MC 1.1: SHORT ANSWER

"Ground Zero" primarily encompasses downtown. Portions of "Ground Zero" overlap slightly into the Plainville (North), Northville (South East) and Westside (South East) areas. Once the first day and historical data trends have been analyzed, it is highly logical and strongly reasonable to deduce that the first infection is centered in downtown because this is the largest area consistently reporting text terms which can be linked to epidemic identification symptoms.

SOLUTION MC 1.2: DETAILED ANSWER

TRKDASH

FILTER1: Set ALL for Type, Symptom, Weather, Wind Direction, and Wind AVG Speed; Choose 4/30/11 (date drop down bar)

FINDING1: Suspected case clusters are typically condensed within the downtown.

FILTER2: Set date BAR from 4/30/11 through 5/20/11 and click on PLAY (right arrow button)

FINDING2: Suspected case clusters continued high in the downtown area from 4/30/11-5/17/11.

CNTDASH

FILTER1: Set ALL for Type, Symptom, Weather, Wind AVG Speed (full range);Choose 4/30/11 (date drop down bar);Select each filter separately for Wind Direction.

FINDING1: Highest Grand Total cases Wind Direction score: NW 29,004;W 18,062;WNW 16,016.

FILTER2: Set ALL for Type, Symptom, Wind Direction, and Set Wind AVG Speed (full range); Choose 4/30/11 (date drop down bar);Select each filter separately for Weather.

FINDING2:Highest Grand Total cases by Weather score: CLOUDY 42,655; CLEAR 27,293.

FILTER3: Set ALL for Type, Symptom, Wind AVG Speed (full range);Choose 4/30/11 (date drop down bar);Set CLEAR and CLOUDY for Weather; Set NW, W and WNW for Wind Direction.

FINDING3: Highest Grand Total case counts combined 60,648 (Tier5: 26,611; Tier6 18,700).

The T7 group (duplicate case, long/lat, date) should be unselected to increase informational reporting quality. The T5 group reports SICK (4,980), FEVER (5,316) and COLD (3,650) have the highest case Grand Totals. On May 18, 19th and 20th, case counts substantially spike upward for key words - hospital, nurse, medicine, flu, pneumonia, cold, cough, diarrhea, fever, headache, sick, throat. The evolution of the pandemic event may have matured beyond the initial incubation period. However, Wind Direction and Weather are also factors in case growth under conditions reported in CNTDASH. Additionally, the pandemic event may have escalated within the entire region because person-2-person transmission exposure has grown as individuals continued to travel in/out of "ground zero". It is wise to dispatch specialized first responders to mitigate further potential loss of life as the phase II cluster of this pandemic event becomes a larger public health threat. In order to possibly avoid unnecessary panic and civil unrest, it may also be prudent to issue general public health safety announcements (TV, radio, print, .etc) for the entire region. Additional statistical data scores reporting individual age, sex and/or race factors would produce greater quantitative and qualitative evidence necessary for achieving an optimal targeted response strategy. Future scoring adjustments are required to clarify symptom text words like fire, needle, shot, etc,. Existing indicators can be misleading and unqualified outliners which should be unselected filters because these words also convey contextual meaning which falls outside of the medical domain.